use ClientDW
db.EsgRating.ensureIndex({ CompanyId: 1, WeightMatrixId: 1 }, { name: "CompanyIdIndex", unique: true });
db.EsgRating.ensureIndex({ TotalScore: 1, WeightMatrixId: 1 }, { name: "TotalScoreIndex" });
db.EsgRating.ensureIndex({ EnvironmentScore: 1, WeightMatrixId: 1 }, { name: "EnvironmentScoreIndex" });
db.EsgRating.ensureIndex({ SocialScore: 1, WeightMatrixId: 1 }, { name: "SocialScoreIndex" });
db.EsgRating.ensureIndex({ GovernanceScore: 1, WeightMatrixId: 1 }, { name: "GovernanceScoreIndex" });
db.EsgRating.ensureIndex({ PreparednessScore: 1, WeightMatrixId: 1 }, { name: "PreparednessScoreIndex" });
db.EsgRating.ensureIndex({ DisclosureScore: 1, WeightMatrixId: 1 }, { name: "DisclosureScoreIndex" });
db.EsgRating.ensureIndex({ QualitativePerformanceScore: 1, WeightMatrixId: 1 }, { name: "QualitativePerformanceScoreIndex" });
db.EsgRating.ensureIndex({ QuantitativePerformanceScore: 1, WeightMatrixId: 1 }, { name: "QuantitativePerformanceScoreIndex" });